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