UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXtLi9k39fBbk4EouPmVfnP+Ux8Y3enVbZx7bfNOHic='
WHERE
key_id = 'ff0cfe54d7bf8cda3d995cb2be5880e933133149b3751194a8e32fca446a07c0'
AND (
token = 'qXtLi9k39fBbk4EouPmVfnP+Ux8Y3enVbZx7bfNOHic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)