UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'flG8/ZAt7HbvImn/mASW8pHjtVpElZr1IE/+DuR/vfY='
WHERE
key_id = '5689c2a71ae5c04dd7a2025d600e77b7c36e29647d29aacd554191473165882f'
AND (
token = 'flG8/ZAt7HbvImn/mASW8pHjtVpElZr1IE/+DuR/vfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)