UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rm5Ew7MhDk9+B2f78H1s67emU7610aX+SFref+FZcgU='
WHERE
key_id = '9eeb3fc58d40f16c8b8df31b4417d10fa93c805aa8fe7cc8118feb03b28fdd4c'
AND (
token = 'rm5Ew7MhDk9+B2f78H1s67emU7610aX+SFref+FZcgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)