UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tVTxgZ/yk9oJstVqzDnhu7OIF7p2R8lFNSpLVY3hKOE='
WHERE
key_id = 'c8838ce0a009a1298a007eb1d74d53743915f5c0592a58249c4ecc95031cede6'
AND (
token = 'tVTxgZ/yk9oJstVqzDnhu7OIF7p2R8lFNSpLVY3hKOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)