UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7ecJTVhVGci2xdKLHoE+eQiesX0IDSTeBAR4OUAJRE='
WHERE
key_id = '8864357632100b28fff5d3c9e9df2f29f8ced6ef6d9f3e92b54a80287933ea3d'
AND (
token = 'e7ecJTVhVGci2xdKLHoE+eQiesX0IDSTeBAR4OUAJRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)