UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZZzIdg0bPOR5Ckl20WrhORPyvokvzKm31lrh3emawo='
WHERE
key_id = 'c1a92e27c4e5d944d28d2f0b04104cb4709f06df9d712dfbb5ef9a8211ee7eda'
AND (
token = '1ZZzIdg0bPOR5Ckl20WrhORPyvokvzKm31lrh3emawo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)