UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lby+hobYhyU+J7SpEgqOBUUa9ySeF5SNLqrG57pW6Zk='
WHERE
key_id = '528a19ac0ad9265f119949b761ae8bfddf9c4458d771f3c0c6d23d15635b9168'
AND (
token = 'lby+hobYhyU+J7SpEgqOBUUa9ySeF5SNLqrG57pW6Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)