UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YV6CxFH1ikbHtMFO1AXVC/NsrY9X2yQHm0iP0Skhqw='
WHERE
key_id = '0f7020a687f0544a2d9584c7b72b24be0bc7dab64276b60ae6db6f56a664d134'
AND (
token = '9YV6CxFH1ikbHtMFO1AXVC/NsrY9X2yQHm0iP0Skhqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)