UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vmsw5Ifa0N+ewMXwazr9QUj6v4JAV1YbFFs1tW9+elg='
WHERE
key_id = 'ca598db474788f05c4fbeab34b5f8a34ce00297c2af68e50d1dad4071ac66134'
AND (
token = 'Vmsw5Ifa0N+ewMXwazr9QUj6v4JAV1YbFFs1tW9+elg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)