UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZe4vxe9mlIWCC31f1T0qVnWrU27xg+x0+zOhaph6TU='
WHERE
key_id = 'bab1176fb252a1de3f7efe4fcd6841b7b755e3f0b05f9a6c80f5a2939389a0b1'
AND (
token = 'hZe4vxe9mlIWCC31f1T0qVnWrU27xg+x0+zOhaph6TU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)