UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXYd+SF/53yfpc3pi/1wB79hKAHzR77uJgGFbRr/SpE='
WHERE
key_id = 'e19de02dddf8ad5d757b654bcd913366e976c2676424263e654049931bdfd9fe'
AND (
token = 'nXYd+SF/53yfpc3pi/1wB79hKAHzR77uJgGFbRr/SpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)