UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVS9E16cQlVMlL8Blle+xDJRvd0dlBFDRrjLNUtyUZs='
WHERE
key_id = 'cded6473163a76898c58a5177249614c2f46d70dff3bf5b9e5e5af261ed143e3'
AND (
token = 'NVS9E16cQlVMlL8Blle+xDJRvd0dlBFDRrjLNUtyUZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)