UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3o5bh9xildirQc7e2dIXEd3LpG12NwejSIwN8SijVkI='
WHERE
key_id = '12bc300bf20b8fdd0cd949869409cd4a9768816b62c5448b4ef16b4ea4e50031'
AND (
token = '3o5bh9xildirQc7e2dIXEd3LpG12NwejSIwN8SijVkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)