UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fGvNWgy1wGlcoDUgU9uhrbVXVhmggyHalC4hEAWcaFo='
WHERE
key_id = '27ec5f781ba39f25e215694a8cac59a77f3220514fec3f53848e6e677c6cb616'
AND (
token = 'fGvNWgy1wGlcoDUgU9uhrbVXVhmggyHalC4hEAWcaFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)