UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RRp/pFVawbdSzDUQ1jmmR17ihq8k9pAe8hoeYSME8Kc='
WHERE
key_id = '47116ea0ed806d61ec1fc360c4c825e396feb902b499b9d6c9b53f865db3deee'
AND (
token = 'RRp/pFVawbdSzDUQ1jmmR17ihq8k9pAe8hoeYSME8Kc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)