UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KW7kPPqw/9PjIEhF+0RGSDGqz5yAOek+XzxIEShOUOo='
WHERE
key_id = 'b5696d47065571d6ce5472f66d56e04beab44799a9aabcd39266eb80fd05e71c'
AND (
token = 'KW7kPPqw/9PjIEhF+0RGSDGqz5yAOek+XzxIEShOUOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)