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