UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgCYySUNy5SX64EyH1bA29r4wyMOjMc9QEZKR60yfc0='
WHERE
key_id = '786ec7e39bdf8b3478caf944dfaa063213403cdaf81e8c5dd34112afd7ebc4b8'
AND (
token = 'BgCYySUNy5SX64EyH1bA29r4wyMOjMc9QEZKR60yfc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)