UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mSodNFIKTscMtf1v1vKITN7l2aIUxBRvOOnZMFr6uE4='
WHERE
key_id = 'bb3c9f08015efb0cfc6ff9a6b0704e4a6b5cbd0024d5a4b473276badb41dcf24'
AND (
token = 'mSodNFIKTscMtf1v1vKITN7l2aIUxBRvOOnZMFr6uE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)