UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2almDY0p6EL76z4+Z4jIEl7h1lbMGIGE9n8xtgZ3Xag='
WHERE
key_id = 'e6905cd2df80703e1e3b943aeec4a8bef9bbcaa797473022beadd7c781fdd817'
AND (
token = '2almDY0p6EL76z4+Z4jIEl7h1lbMGIGE9n8xtgZ3Xag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)