UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCiobU5g6jhUOKRLaUFKjOyNKpuzWies/F6ZaJ4+Oks='
WHERE
key_id = 'd7af2ff2b87cd938c7324ee188ee813d7cd54a3f20bc4f4a976b88a0be669786'
AND (
token = 'pCiobU5g6jhUOKRLaUFKjOyNKpuzWies/F6ZaJ4+Oks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)