UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3mI8KMGDNh0b+iwhElHy92yXKzBmhTGnq1b1/KjeSsQ='
WHERE
key_id = '2470630c7fa2f2dff25a1dc64d5c2cd173583fda9cdcf46c16b4b9ad73d8f730'
AND (
token = '3mI8KMGDNh0b+iwhElHy92yXKzBmhTGnq1b1/KjeSsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)