UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U4QlhY9ZnHUT9WWyJAHdwtn9OYtuqeZ3hcKqoiIj1wk='
WHERE
key_id = '208ebb92360e48d90930ca117ad4af580a11e397b3324f23dce5cb46e767c575'
AND (
token = 'U4QlhY9ZnHUT9WWyJAHdwtn9OYtuqeZ3hcKqoiIj1wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)