UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '587qYmkBij35GDuw0gBnd3zeJlJ6yN523QtlCC5t46Q='
WHERE
key_id = 'ee690bab65b798706fc949e31d5e7903e9be8b697db6735f133888a7cf40b3a1'
AND (
token = '587qYmkBij35GDuw0gBnd3zeJlJ6yN523QtlCC5t46Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)