UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/D/gpVy18t1WfLBnCYP5/qu3NpjdIwRipvvSi6z0EG0='
WHERE
key_id = 'f3f4693ffa06f7a692ef8e95cef7bd5c8e1467f7ed4d9a6d6917018172f9dc59'
AND (
token = '/D/gpVy18t1WfLBnCYP5/qu3NpjdIwRipvvSi6z0EG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)