UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4A7JZF1cjtLkNQNfQc4Moz5jMsUFiGot3IrmqmycA6k='
WHERE
key_id = 'db288ca2a1ba33797a953e4614a20b6d10a2d3996889a680ac068bb4a19b243b'
AND (
token = '4A7JZF1cjtLkNQNfQc4Moz5jMsUFiGot3IrmqmycA6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)