UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CrhLuTqjdtnZ64eb0/WLmp5CUR9MB2lI6W0jMIaTG0k='
WHERE
key_id = 'd1a36e8915fe0bd850a02dc6e63b6f8896f773dd2c8f2edba970d5057c1b3d24'
AND (
token = 'CrhLuTqjdtnZ64eb0/WLmp5CUR9MB2lI6W0jMIaTG0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)