UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQEAuoyGtaIPlccpWcPjPCFuKYXtSb7fY8lfp0KOnhk='
WHERE
key_id = 'a7bd00840443eb9a15343afe1dadd29b33a31992b94c22c1535385fa2577565b'
AND (
token = 'tQEAuoyGtaIPlccpWcPjPCFuKYXtSb7fY8lfp0KOnhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)