UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V7+EId+hTFfH8tOm2KpWmlvrTK/H5NnPm8gNp3+IkO0='
WHERE
key_id = 'a56aaac0ec4d66fbe07685fb9c6be160ebef25f4cc4b715a90fdc793e344bb7b'
AND (
token = 'V7+EId+hTFfH8tOm2KpWmlvrTK/H5NnPm8gNp3+IkO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)