UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rg502/NLZB0OtQMQNy1vLJBHszIqOAwrk3EvF9U6c4s='
WHERE
key_id = 'aff01ea542900d54f78ecd3707b6986b27a238569963f0725b753e48dd54c36a'
AND (
token = 'Rg502/NLZB0OtQMQNy1vLJBHszIqOAwrk3EvF9U6c4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)